﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
/****** Object:  Table [dbo].[Countries]    Script Date: 10/20/2010 13:09:37 ******/
SET IDENTITY_INSERT [dbo].[Countries] ON
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (1, N'')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (2, N'Afghanistan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (3, N'Akrotiri')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (4, N'Albania')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (5, N'Algeria')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (6, N'American Samoa')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (7, N'Andorra')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (8, N'Angola')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (9, N'Anguilla')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (10, N'Antarctica')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (11, N'Antigua and Barbuda')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (12, N'Argentina')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (13, N'Armenia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (14, N'Aruba')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (15, N'Ashmore and Cartier Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (16, N'Australia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (17, N'Austria')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (18, N'Azerbaijan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (19, N'Bahamas, The')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (20, N'Bahrain')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (21, N'Bangladesh')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (22, N'Barbados')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (23, N'Bassas da India')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (24, N'Belarus')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (25, N'Belgium')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (26, N'Belize')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (27, N'Benin')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (28, N'Bermuda')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (29, N'Bhutan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (30, N'Bolivia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (31, N'Bosnia and Herzegovina')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (32, N'Botswana')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (33, N'Bouvet Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (34, N'Brazil')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (35, N'British Indian Ocean Territory')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (36, N'British Virgin Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (37, N'Brunei')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (38, N'Bulgaria')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (39, N'Burkina Faso')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (40, N'Burma')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (41, N'Burundi')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (42, N'Cambodia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (43, N'Cameroon')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (44, N'Canada')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (45, N'Cape Verde')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (46, N'Cayman Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (47, N'Central African Republic')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (48, N'Chad')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (49, N'Chile')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (50, N'China')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (51, N'Christmas Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (52, N'Clipperton Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (53, N'Cocos (Keeling) Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (54, N'Colombia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (55, N'Comoros')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (56, N'Congo, Democratic Republic of the')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (57, N'Congo, Republic of the')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (58, N'Cook Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (59, N'Coral Sea Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (60, N'Costa Rica')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (61, N'Cote d''Ivoire')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (62, N'Croatia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (63, N'Cuba')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (64, N'Cyprus')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (65, N'Czech Republic')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (66, N'Denmark')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (67, N'Dhekelia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (68, N'Djibouti')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (69, N'Dominica')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (70, N'Dominican Republic')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (71, N'Ecuador')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (72, N'Egypt')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (73, N'El Salvador')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (74, N'Equatorial Guinea')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (75, N'Eritrea')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (76, N'Estonia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (77, N'Ethiopia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (78, N'Europa Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (79, N'Falkland Islands (Islas Malvinas)')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (80, N'Faroe Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (81, N'Fiji')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (82, N'Finland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (83, N'France')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (84, N'French Guiana')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (85, N'French Polynesia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (86, N'French Southern and Antarctic Lands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (87, N'Gabon')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (88, N'Gambia, The')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (89, N'Gaza Strip')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (90, N'Georgia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (91, N'Germany')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (92, N'Ghana')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (93, N'Gibraltar')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (94, N'Glorioso Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (95, N'Greece')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (96, N'Greenland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (97, N'Grenada')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (98, N'Guadeloupe')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (99, N'Guam')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (100, N'Guatemala')
GO
print 'Processed 100 total records'
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (101, N'Guernsey')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (102, N'Guinea')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (103, N'Guinea-Bissau')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (104, N'Guyana')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (105, N'Haiti')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (106, N'Heard Island and McDonald Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (107, N'Holy See (Vatican City)')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (108, N'Honduras')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (109, N'Hong Kong')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (110, N'Hungary')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (111, N'Iceland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (112, N'India')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (113, N'Indonesia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (114, N'Iran')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (115, N'Iraq')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (116, N'Ireland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (117, N'Isle of Man')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (118, N'Israel')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (119, N'Italy')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (120, N'Jamaica')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (121, N'Jan Mayen')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (122, N'Japan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (123, N'Jersey')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (124, N'Jordan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (125, N'Juan de Nova Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (126, N'Kazakhstan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (127, N'Kenya')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (128, N'Kiribati')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (129, N'Korea, North')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (130, N'Korea, South')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (131, N'Kuwait')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (132, N'Kyrgyzstan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (133, N'Laos')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (134, N'Latvia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (135, N'Lebanon')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (136, N'Lesotho')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (137, N'Liberia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (138, N'Libya')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (139, N'Liechtenstein')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (140, N'Lithuania')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (141, N'Luxembourg')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (142, N'Macau')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (143, N'Macedonia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (144, N'Madagascar')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (145, N'Malawi')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (146, N'Malaysia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (147, N'Maldives')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (148, N'Mali')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (149, N'Malta')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (150, N'Marshall Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (151, N'Martinique')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (152, N'Mauritania')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (153, N'Mauritius')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (154, N'Mayotte')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (155, N'Mexico')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (156, N'Micronesia, Federated States of')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (157, N'Moldova')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (158, N'Monaco')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (159, N'Mongolia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (160, N'Montserrat')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (161, N'Morocco')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (162, N'Mozambique')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (163, N'Namibia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (164, N'Nauru')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (165, N'Navassa Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (166, N'Nepal')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (167, N'Netherlands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (168, N'Netherlands Antilles')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (169, N'New Caledonia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (170, N'New Zealand')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (171, N'Nicaragua')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (172, N'Niger')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (173, N'Nigeria')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (174, N'Niue')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (175, N'Norfolk Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (176, N'Northern Mariana Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (177, N'Norway')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (178, N'Oman')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (179, N'Pakistan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (180, N'Palau')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (181, N'Panama')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (182, N'Papua New Guinea')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (183, N'Paracel Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (184, N'Paraguay')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (185, N'Peru')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (186, N'Philippines')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (187, N'Pitcairn Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (188, N'Poland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (189, N'Portugal')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (190, N'Puerto Rico')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (191, N'Qatar')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (192, N'Reunion')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (193, N'Romania')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (194, N'Russia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (195, N'Rwanda')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (196, N'Saint Helena')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (197, N'Saint Kitts and Nevis')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (198, N'Saint Lucia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (199, N'Saint Pierre and Miquelon')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (200, N'Saint Vincent and the Grenadines')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (201, N'Samoa')
GO
print 'Processed 200 total records'
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (202, N'San Marino')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (203, N'Sao Tome and Principe')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (204, N'Saudi Arabia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (205, N'Senegal')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (206, N'Serbia and Montenegro')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (207, N'Seychelles')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (208, N'Sierra Leone')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (209, N'Singapore')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (210, N'Slovakia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (211, N'Slovenia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (212, N'Solomon Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (213, N'Somalia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (214, N'South Africa')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (215, N'South Georgia and the South Sandwich Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (216, N'Spain')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (217, N'Spratly Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (218, N'Sri Lanka')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (219, N'Sudan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (220, N'Suriname')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (221, N'Svalbard')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (222, N'Swaziland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (223, N'Sweden')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (224, N'Switzerland')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (225, N'Syria')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (226, N'Taiwan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (227, N'Tajikistan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (228, N'Tanzania')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (229, N'Thailand')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (230, N'Timor-Leste')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (231, N'Togo')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (232, N'Tokelau')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (233, N'Tonga')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (234, N'Trinidad and Tobago')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (235, N'Tromelin Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (236, N'Tunisia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (237, N'Turkey')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (238, N'Turkmenistan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (239, N'Turks and Caicos Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (240, N'Tuvalu')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (241, N'Uganda')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (242, N'Ukraine')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (243, N'United Arab Emirates')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (244, N'United Kingdom')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (245, N'United States')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (246, N'Uruguay')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (247, N'Uzbekistan')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (248, N'Vanuatu')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (249, N'Venezuela')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (250, N'Vietnam')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (251, N'Virgin Islands')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (252, N'Wake Island')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (253, N'Wallis and Futuna')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (254, N'West Bank')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (255, N'Western Sahara')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (256, N'Yemen')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (257, N'Zambia')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (258, N'Zimbabwe')
SET IDENTITY_INSERT [dbo].[Countries] OFF
/****** Object:  Table [dbo].[Nationalities]    Script Date: 10/20/2010 13:09:37 ******/
SET IDENTITY_INSERT [dbo].[Nationalities] ON
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (1, N'Afghan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (2, N'Albanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (3, N'Algerian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (4, N'American')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (5, N'Andorran')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (6, N'Angolan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (7, N'Antiguans')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (8, N'Argentinean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (9, N'Armenian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (10, N'Australian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (11, N'Austrian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (12, N'Azerbaijani')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (13, N'Bahamian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (14, N'Bahraini')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (15, N'Bangladeshi')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (16, N'Barbadian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (17, N'Barbudans')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (18, N'Batswana')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (19, N'Belarusian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (20, N'Belgian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (21, N'Belizean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (22, N'Beninese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (23, N'Bhutanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (24, N'Bolivian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (25, N'Bosnian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (26, N'Brazilian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (27, N'British')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (28, N'Bruneian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (29, N'Bulgarian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (30, N'Burkinabe')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (31, N'Burmese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (32, N'Burundian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (33, N'Cambodian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (34, N'Cameroonian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (35, N'Canadian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (36, N'Cape Verdean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (37, N'Central African')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (38, N'Chadian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (39, N'Chilean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (40, N'Chinese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (41, N'Colombian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (42, N'Comoran')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (43, N'Congolese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (44, N'Congolese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (45, N'Costa Rican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (46, N'Croatian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (47, N'Cuban')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (48, N'Cypriot')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (49, N'Czech')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (50, N'Danish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (51, N'Djibouti')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (52, N'Dominican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (53, N'Dominican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (54, N'Dutch')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (55, N'East Timorese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (56, N'Ecuadorean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (57, N'Egyptian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (58, N'Emirian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (59, N'Equatorial Guinean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (60, N'Eritrean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (61, N'Estonian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (62, N'Ethiopian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (63, N'Fijian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (64, N'Filipino')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (65, N'Finnish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (66, N'French')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (67, N'Gabonese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (68, N'Gambian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (69, N'Georgian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (70, N'German')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (71, N'Ghanaian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (72, N'Greek')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (73, N'Grenadian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (74, N'Guatemalan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (75, N'Guinea-Bissauan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (76, N'Guinean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (77, N'Guyanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (78, N'Haitian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (79, N'Herzegovinian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (80, N'Honduran')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (81, N'Hungarian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (82, N'Icelander')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (83, N'Indian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (84, N'Indonesian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (85, N'Iranian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (86, N'Iraqi')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (87, N'Irish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (88, N'Israeli')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (89, N'Italian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (90, N'Ivorian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (91, N'Jamaican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (92, N'Japanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (93, N'Jordanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (94, N'Kazakhstani')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (95, N'Kenyan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (96, N'Kittian and Nevisian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (97, N'Kuwaiti')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (98, N'Kyrgyz')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (99, N'Laotian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (100, N'Latvian')
GO
print 'Processed 100 total records'
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (101, N'Lebanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (102, N'Liberian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (103, N'Libyan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (104, N'Liechtensteiner')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (105, N'Lithuanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (106, N'Luxembourger')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (107, N'Macedonian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (108, N'Malagasy')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (109, N'Malawian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (110, N'Malaysian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (111, N'Maldivan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (112, N'Malian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (113, N'Maltese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (114, N'Marshallese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (115, N'Mauritanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (116, N'Mauritian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (117, N'Mexican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (118, N'Micronesian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (119, N'Moldovan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (120, N'Monacan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (121, N'Mongolian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (122, N'Moroccan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (123, N'Mosotho')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (124, N'Motswana')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (125, N'Mozambican')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (126, N'Namibian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (127, N'Nauruan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (128, N'Nepalese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (129, N'Netherlander')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (130, N'New Zealander')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (131, N'Ni-Vanuatu')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (132, N'Nicaraguan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (133, N'Nigerian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (134, N'Nigerien')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (135, N'North Korean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (136, N'Northern Irish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (137, N'Norwegian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (138, N'Omani')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (139, N'Pakistani')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (140, N'Palauan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (141, N'Panamanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (142, N'Papua New Guinean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (143, N'Paraguayan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (144, N'Peruvian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (145, N'Polish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (146, N'Portuguese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (147, N'Qatari')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (148, N'Romanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (149, N'Russian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (150, N'Rwandan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (151, N'Saint Lucian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (152, N'Salvadoran')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (153, N'Samoan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (154, N'San Marinese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (155, N'Sao Tomean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (156, N'Saudi')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (157, N'Scottish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (158, N'Senegalese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (159, N'Serbian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (160, N'Seychellois')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (161, N'Sierra Leonean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (162, N'Singaporean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (163, N'Slovakian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (164, N'Slovenian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (165, N'Solomon Islander')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (166, N'Somali')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (167, N'South African')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (168, N'South Korean')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (169, N'Spanish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (170, N'Sri Lankan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (171, N'Sudanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (172, N'Surinamer')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (173, N'Swazi')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (174, N'Swedish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (175, N'Swiss')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (176, N'Syrian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (177, N'Taiwanese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (178, N'Tajik')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (179, N'Tanzanian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (180, N'Thai')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (181, N'Togolese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (182, N'Tongan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (183, N'Trinidadian or Tobagonian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (184, N'Tunisian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (185, N'Turkish')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (186, N'Tuvaluan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (187, N'Ugandan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (188, N'Ukrainian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (189, N'Uruguayan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (190, N'Uzbekistani')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (191, N'Venezuelan')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (192, N'Vietnamese')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (193, N'Welsh')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (194, N'Yemenite')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (195, N'Zambian')
INSERT [dbo].[Nationalities] ([NationalityId], [NationalityName]) VALUES (196, N'Zimbabwean')
SET IDENTITY_INSERT [dbo].[Nationalities] OFF
/****** Object:  Table [dbo].[Modules]    Script Date: 10/20/2010 13:09:37 ******/
SET IDENTITY_INSERT [dbo].[Modules] ON
INSERT [dbo].[Modules] ([ModuleId], [ModuleName]) VALUES (7, N'Library')
INSERT [dbo].[Modules] ([ModuleId], [ModuleName]) VALUES (8, N'Meeting')
INSERT [dbo].[Modules] ([ModuleId], [ModuleName]) VALUES (9, N'Attendance')
INSERT [dbo].[Modules] ([ModuleId], [ModuleName]) VALUES (10, N'Visitation')
SET IDENTITY_INSERT [dbo].[Modules] OFF
/****** Object:  Table [dbo].[Emails]    Script Date: 10/20/2010 13:09:37 ******/
SET IDENTITY_INSERT [dbo].[Emails] ON
INSERT [dbo].[Emails] ([EmailId], [Code], [TemplateResourcesPaths], [Description], [Template], [Subject]) VALUES (1, N'0001 ', N'empty', N'dummy template', N'Dear {0},<br />
<br />
Welcome to churchtoolkit.net<br />
your username is {1}<br />
your password is {2}<br />
<br />
<span class="Apple-style-span" style="line-height: normal; widows: 2; text-transform: none; font-variant: normal; font-style: normal; text-indent: 0px; border-collapse: collapse; font-family: ; white-space: normal; orphans: 2; letter-spacing: normal; color: #000000; font-weight: normal; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">Please use the link below to activate your account<br />
{3}<br />
<br />
Beast regards<br />
Churchtoolkit team</span>', N'Welcome to churchtoolkit.net')
INSERT [dbo].[Emails] ([EmailId], [Code], [TemplateResourcesPaths], [Description], [Template], [Subject]) VALUES (2, N'0002 ', N'Password', N'Forget Password Mail template', N'Dear {0},<br />
<br />
<span style="font-weight: bold; text-decoration: underline">your forgotten Password:</span> {1}<br />
<br />
<p style="text-align: right; margin: 0px">Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; </p>
<p style="text-align: right; margin: 0px">ChurchToolKit Team</p>', N'Your Password')
SET IDENTITY_INSERT [dbo].[Emails] OFF
/****** Object:  Table [dbo].[Errors]    Script Date: 10/20/2010 13:09:37 ******/
SET IDENTITY_INSERT [dbo].[Errors] ON
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (4, N'0001 ', N'[Field] is required', N'[Field] is required')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (8, N'0003 ', N'Please enter a valid email', N'Please enter a valid email')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (9, N'0004 ', N'You login attempt failed, please check your username or password and try again ', N'You login attempt failed, please check your username or password and try again ')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (10, N'0005 ', N'Member Is Not Active', N'Member Is Not Active')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (11, N'0006 ', N'No special characters allowed', N'No special characters allowed')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (12, N'0007 ', N'[Field] contains only numbers', N'[Field] contains only numbers')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (13, N'0008 ', N'Invaild allow only Numbers', N'Invaild allow only Numbers')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (16, N'0009 ', N'Invaild Birthday', N' ,Must be more Than 18 Year')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (17, N'0010 ', N'The file is not an image', N'The file is not an image')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (18, N'0011 ', N'The image is too big , shouldn''t exceed 4mb', N'The image is too big , shouldn''t exceed 4mb')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (19, N'0002 ', N'this email is already registered', N'this email is already registered')
INSERT [dbo].[Errors] ([ErrorId], [Code], [Message], [Description]) VALUES (20, N'0012 ', N'the password confirmation dose not match the password', N'the password confirmation dose not match the password')
SET IDENTITY_INSERT [dbo].[Errors] OFF
